<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateSLessonInfo extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('s_lesson_info', function (Blueprint $table) {
            $table->increments('id');

            $table->integer('user_id')->comment("学生id")->index();
            $table->integer('teacher_id')->comment("老师id")->index();

            $table->integer('lesson_type_id')->comment("类型id")->index();

            $table->integer('cloud_id')->comment("类型id")->index();

            $table->dateTime('begin_time')->comment("开始时间")->index();
            $table->dateTime('end_time')->comment("结束时间")->index();
            
            $table->integer('lesson_status')->comment("课程状态");
            $table->integer('lesson_cancle')->comment("课程取消标志")->default(0);

            $table->integer('send_notice')->comment('发送短息提示');

            $table->integer('evaluate_explain')->comment('评价，讲解清晰指数');
            $table->integer('evaluate_vivid')->comment('评价，生动有效指数');
            $table->integer('evaluate_expand')->comment('评价，拓展知识指数');
            $table->string('evaluate_advice', 3000)->comment('评价，建议');

            $table->timestamps();
            $table->SoftDeletes();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}
